﻿-- Table Vai Tro 
Go
INSERT INTO VaiTro VALUES(N'Admin',GETDATE(),'','','','','')
INSERT INTO VaiTro VALUES(N'Hiệu Trưởng',GETDATE(),'','','','','')
INSERT INTO VaiTro VALUES(N'Hiệu Phó',GETDATE(),'','','','','')
INSERT INTO VaiTro VALUES(N'Trưởng Phòng',GETDATE(),'','','','','')
INSERT INTO VaiTro VALUES(N'Phó Phòng',GETDATE(),'','','','','')
INSERT INTO VaiTro VALUES(N'Trưởng Khoa',GETDATE(),'','','','','')
INSERT INTO VaiTro VALUES(N'Phó Khoa',GETDATE(),'','','','','')
INSERT INTO VaiTro VALUES(N'Trưởng Bộ Môn',GETDATE(),'','','','','')
INSERT INTO VaiTro VALUES(N'Giáo Viên',GETDATE(),'','','','','')
INSERT INTO VaiTro VALUES(N'Sinh Viên',GETDATE(),'','','','','')
INSERT INTO VaiTro VALUES(N'Giám Đốc Trung Tâm',GETDATE(),'','','','','')
INSERT INTO VaiTro VALUES(N'Nhân Viên',GETDATE(),'','','','','')

-- Table ChiTietThanhVien
Go
INSERT INTO ChiTietThanhVien VALUES('ThienVD',N'Võ',N'Đức',N'Thiện',getdate(),null,'','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hai_tv',N'Trần',N'Văn',N'Hải',getdate(),null,'','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hanh_nn',N'Nguyễn',N'Ngọc',N'Hạnh',getdate(),null,'','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hanh_vtb',N'Võ',N'Thị Bích',N'Hạnh',getdate(),null,'','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('dung_nn',N'Ngô',N'Ngọc',N'Dung',getdate(),null,'','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('han_nkn',N'Nguyễn',N'Khắc Ngọc',N'Hân',getdate(),null,'','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hoi_tt',N'Trần',N'Thị',N'Hội',getdate(),null,'@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('nhan_nh',N'Nguyễn',N'Hữu',N'Nhân',getdate(),null,'@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('cong_nd',N'Nguyễn',N'Đình',N'Công',getdate(),null,'cd@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('chau_dcb',N'Đỗ',N'Cao Bảo',N'Châu',getdate(),null,'cb@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('loi_nt',N'Nguyễn',N'Tấn',N'Lợi',getdate(),null,'lo@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('tran_dtt',N'Đoàn',N'Thị Thanh',N'Trân',getdate(),null,'ttt@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('luong_nt',N'Nguyễn',N'Trọng',N'Lượng',getdate(),null,'lu_nt@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('trung_th',N'Trương',N'Hòa',N'Trung',getdate(),null,'g_th@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('ngoc_dtt',N'Đặng',N'Thị Thu',N'Ngọc',getdate(),null,'n@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hong_nt',N'Nguyễn',N'Thị',N'Hồng',getdate(),null,'ht@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('quyen_nlq',N'Nguyễn',N'Lê Quyên',N'Quyên',getdate(),null,'lq@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hien_ntt',N'Nguyễn',N'Thị Thu',N'Hiền',getdate(),null,'hit@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('trieu_nht',N'Nguyễn',N'Huỳnh Thủy',N'Triều',getdate(),null,'eu_t@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('oanh_dtt',N'Đinh',N'Thị Tường',N'Oanh',getdate(),null,'ott@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('cuong_nq',N'Nguyễn',N'Quốc',N'Cường',getdate(),null,'cuq@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('truong_dq',N'Dương',N'Quang',N'Trường',getdate(),null,'trq@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('khanh_lb',N'Lê',N'Bảo',N'Khanh',getdate(),null,'klb@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('dang_nh',N'Nguyễn',N'Hữu',N'Đăng',getdate(),null,'dah@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('dung_dn',N'Dương',N'Ngọc',N'Dũng',getdate(),null,'dn@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('dung_nd',N'Nguyễn',N'Đức',N'Dũng',getdate(),null,'dnd@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('minh_lt',N'Lê',N'Thanh','Minh',getdate(),null,'mt@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('bang_ck',N'Châu',N'Kim',N'Bảng',getdate(),null,'bk@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('uyen_bmt',N'Bùi',N'Mộng Thúy',N'Uyên',getdate(),null,'umt@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('TruongBoMon',N'Trưởng',N'Bộ',N'Môn',getdate(),null,'duhtn@gmail.com','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('truong_tht',N'Tô',N'Huỳnh Thiên',N'Trường',getdate(),null,'trut@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('trung_pn',N'Phan',N'Nhật',N'Trung',getdate(),null,'@huongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('lam_vt',N'Võ',N'Thị',N'Lắm',getdate(),null,'lt@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('linh_lqh',N'Lê',N'Quí Hồng',N'Lĩnh',getdate(),null,'llqh@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('khoa_ng',N'Nguyễn',N'Gia',N'Khoa',getdate(),null,'k_ng@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('tho_nd',N'Ngô',N'Đình',N'Thọ',getdate(),null,'thd@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('chau_pb',N'Phan',N'Bảo',N'Châu',getdate(),null,'c_pb@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('khoa_nvd',N'Nguyễn',N'Võ Đăng',N'Khoa',getdate(),null,'kd@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('truong_bq',N'Bùi',N'Quốc',N'Trưởng',getdate(),null,'tbq@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('phuong_pd',N'Phạm',N'Duy',N'Phương',getdate(),null,'phpd@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hai_dv',N'Đỗ',N'Văn',N'Hải',getdate(),null,'dv@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('duc_pm',N'Phạm',N'Minh',N'Đức',getdate(),null,'dum@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('tan_dp',N'Dương',N'Phước',N'Tấn',getdate(),null,'tp@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('trien_nt',N'Nguyễn',N'Tấn',N'Triển',getdate(),null,'trt@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('tu_pt',N'Phạm',N'Thanh',N'Tú',getdate(),null,'tt@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('thiet_tv',N'Trần',N'Văn',N'Thiệt',getdate(),null,'ttv@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('vu_nm',N'Nguyễn',N'Minh',N'Vũ',getdate(),null,'v@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('phu_nh',N'Nguyễn',N'Hoàn',N'Phú',getdate(),null,'ph@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('minh_nn',N'Nguyễn',N'Ngọc',N'Minh',getdate(),null,'mi@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hau_tt',N'Trần',N'Thanh',N'Hậu',getdate(),null,'ha@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('phuoc_nt',N'Nguyễn',N'Tấn',N'Phước',getdate(),null,'pnt@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('san_h',N'Huỳnh',N'',N'San',getdate(),null,'s@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('kiet_dc',N'Dương',N'Chánh',N'Kiệt',getdate(),null,'kiet_dc@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('nha_mt',N'Mai',N'Thanh',N'Nhã',getdate(),null,'nht@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('binh_nh',N'Nguyễn',N'Hiếu',N'Bình',getdate(),null,'bi@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('thanh_lt',N'Lê',N'Tấn',N'Thanh',getdate(),null,'that@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('tien_pv',N'Phạm',N'Vĩnh',N'Tiên',getdate(),null,'tiv@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('bao_tn',N'Trần',N'Như',N'Bảo',getdate(),null,'b@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('phuong_vh',N'Vương',N'Hoàng',N'Phương',getdate(),null,'_vh@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('minh_pq',N'Phan',N'Quang',N'Minh',getdate(),null,'mq@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('phuong_ptt',N'Phạm',N'Thị Trúc',N'Phương',getdate(),null,'phuong_ptt@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('cam_nd',N'Nhan',N'Đỗ',N'Cẩm',getdate(),null,'cd@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('nhung_ltt',N'Lý',N'Thị Tuyết',N'Nhung',getdate(),null,'nht@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('long_td',N'Trần',N'Đình',N'Long',getdate(),null,'d@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hau_nt',N'Nguyễn',N'Trọng',N'Hậu',getdate(),null,'hat@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('toan_ld',N'Lê',N'Đức',N'Toan',getdate(),null,'to@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('trong_cv',N'Châu',N'Văn',N'Trọng',getdate(),null,'tr@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('thai_tm',N'Trần',N'Minh',N'Thái',getdate(),null,'tm@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('dung_nt',N'Nguyễn',N'Tấn',N'Dũng',getdate(),null,'dt@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('tuan_na',N'Ninh',N'Anh',N'Tuấn',getdate(),null,'a@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('minh_tc',N'Tăng',N'Cẩm',N'Minh',getdate(),null,'mc@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('quoi_vv',N'Võ',N'Văn',N'Qưới',getdate(),null,'q_@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('tho_pp',N'Phạm',N'Phú',N'Thọ',getdate(),null,'t@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('sang_ntn',N'Nguyễn',N'Thị Ngọc',N'Sang',getdate(),null,'sn@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('vy_nh',N'Nguyễn',N'Hùng',N'Vỹ',getdate(),null,'vh@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('toan_bx',N'Bùi',N'Xuân',N'Toàn',getdate(),null,'toa@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('khiem_th',N'Trần',N'Hữu',N'Khiêm',getdate(),null,'kh@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hai_nc',N'Nguyễn',N'Chí',N'Hải',getdate(),null,'h@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('quan_nv',N'Nguyễn',N'Vinh',N'Quan',getdate(),null,'qv@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('an_hv',N'Hồ',N'Vĩnh',N'An',getdate(),null,'v@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('nhan_dh',N'Đinh',N'Hiền',N'Nhân',getdate(),null,'nh@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hong_bv',N'Bùi',N'Văn',N'Hồng',getdate(),null,'ho@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('huy_tq',N'Trần',N'Quang',N'Huy',getdate(),null,'h@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('trung_lc',N'Lý',N'Chánh',N'Trung',getdate(),null,'tru@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('vinh_vq',N'Vũ',N'Quang',N'Vinh',getdate(),null,'v@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('quang_nl',N'Nguyễn',N'Lê',N'Quang',getdate(),null,'ql@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('thong_nv',N'Nguyễn',N'Văn',N'Thông',getdate(),null,'th@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('long_nh',N'Nguyễn',N'Hữu',N'Long',getdate(),null,'l@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('thi_pv',N'Phạm',N'Văn',N'Thì',getdate(),null,'th@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('ha_nh',N'Nguyễn',N'Hoàng',N'Hà',getdate(),null,'h@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('thong_pq',N'Phan',N'Quốc',N'Thông',getdate(),null,'t@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('thoai_lh',N'Lương',N'Hữu',N'Thoại',getdate(),null,'th@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('lan_l',N'Lê',N'',N'Lân',getdate(),null,'la@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('hue_tv',N'Truyện',N'Văn',N'Huệ',getdate(),null,'hu@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('thuy_ln',N'Lê',N'Ngọc',N'Thúy',getdate(),null,'th@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('tung_nt',N'Nguyễn',N'Thanh',N'Tùng',getdate(),null,'t@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('huyen_nt',N'Nguyễn',N'Thị',N'Huyền',getdate(),null,'hu@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')
INSERT INTO ChiTietThanhVien VALUES('tham_nth',N'Nguyễn',N'Thị Hồng',N'Thắm',getdate(),null,'t@hungvuongtech.edu.vn','',null,getdate(),getdate(),null,1,null,null,'','','','','')

-- Table THANHVIEN
Go 
INSERT INTO ThanhVien VALUES('ThienVD','ThienVD',0,GETDATE(),GETDATE(),GETDATE(),16,'','','','','')
INSERT INTO ThanhVien VALUES('hai_tv','hai_tv',1,GETDATE(),GETDATE(),GETDATE(),0,'','','','','')
INSERT INTO ThanhVien VALUES('hanh_nn','hanh_nn',2,GETDATE(),GETDATE(),GETDATE(),0,'','','','','')
INSERT INTO ThanhVien VALUES('hanh_vtb','hanh_vtb',2,GETDATE(),GETDATE(),GETDATE(),0,'','','','','')
INSERT INTO ThanhVien VALUES('dung_nn','dung_nn',4,GETDATE(),GETDATE(),GETDATE(),1,'','','','','')
INSERT INTO ThanhVien VALUES('han_nkn','han_nkn',3,GETDATE(),GETDATE(),GETDATE(),1,'','','','','')
INSERT INTO ThanhVien VALUES('hoi_tt','hoi_tt',11,GETDATE(),GETDATE(),GETDATE(),1,'','','','','')
INSERT INTO ThanhVien VALUES('nhan_nh','nhan_nh',11,GETDATE(),GETDATE(),GETDATE(),1,'','','','','')
INSERT INTO ThanhVien VALUES('cong_nd','cong_nd',11,GETDATE(),GETDATE(),GETDATE(),1,'','','','','')
INSERT INTO ThanhVien VALUES('chau_dcb','chau_dcb',11,GETDATE(),GETDATE(),GETDATE(),1,'','','','','')
INSERT INTO ThanhVien VALUES('loi_nt','loi_nt',4,GETDATE(),GETDATE(),GETDATE(),3,'','','','','')
INSERT INTO ThanhVien VALUES('tran_dtt','tran_dtt',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('luong_nt','luong_nt',11,GETDATE(),GETDATE(),GETDATE(),3,'','','','','')
INSERT INTO ThanhVien VALUES('trung_th','trung_th',3,GETDATE(),GETDATE(),GETDATE(),4,'','','','','')
INSERT INTO ThanhVien VALUES('ngoc_dtt','ngoc_dtt',11,GETDATE(),GETDATE(),GETDATE(),4,'','','','','')
INSERT INTO ThanhVien VALUES('hong_nt','hong_nt',4,GETDATE(),GETDATE(),GETDATE(),2,'','','','','')
INSERT INTO ThanhVien VALUES('quyen_nlq','quyen_nlq',11,GETDATE(),GETDATE(),GETDATE(),2,'','','','','')
INSERT INTO ThanhVien VALUES('hien_ntt','hien_ntt',11,GETDATE(),GETDATE(),GETDATE(),2,'','','','','')
INSERT INTO ThanhVien VALUES('trieu_nht','trieu_nht',3,GETDATE(),GETDATE(),GETDATE(),15,'','','','','')
INSERT INTO ThanhVien VALUES('oanh_dtt','oanh_dtt',11,GETDATE(),GETDATE(),GETDATE(),15,'','','','','')
INSERT INTO ThanhVien VALUES('cuong_nq','cuong_nq',5,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('truong_dq','truong_dq',5,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('khanh_lb','khanh_lb',6,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('dang_nh','dang_nh',6,GETDATE(),GETDATE(),GETDATE(),10,'','','','','')
INSERT INTO ThanhVien VALUES('dung_dn','dung_dn',5,GETDATE(),GETDATE(),GETDATE(),9,'','','','','')
INSERT INTO ThanhVien VALUES('dung_nd','dung_nd',6,GETDATE(),GETDATE(),GETDATE(),9,'','','','','')
INSERT INTO ThanhVien VALUES('minh_lt','minh_lt',5,GETDATE(),GETDATE(),GETDATE(),8,'','','','','')
INSERT INTO ThanhVien VALUES('bang_ck','bang_ck',5,GETDATE(),GETDATE(),GETDATE(),13,'','','','','')
INSERT INTO ThanhVien VALUES('uyen_bmt','uyen_bmt',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('TruongBoMon','TruongBoMon',7,GETDATE(),GETDATE(),GETDATE(),null,'','','','','')
INSERT INTO ThanhVien VALUES('truong_tht','truong_tht',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('trung_pn','trung_pn',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('lam_vt','lam_vt',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('linh_lqh','linh_lqh',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('tho_nd','tho_nd',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('chau_pb','chau_pb',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('khoa_nvd','khoa_nvd',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('truong_bq','truong_bq',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('phuong_pd','phuong_pd',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('hai_dv','hai_dv',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('duc_pm','duc_pm',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('tan_dp','tan_dp',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('trien_nt','trien_nt',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('tu_pt','tu_pt',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('thiet_tv','thiet_tv',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('vu_nm','vu_nm',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('phu_nh','phu_nh',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('minh_nn','minh_nn',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('hau_tt','hau_tt',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('phuoc_nt','phuoc_nt',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('san_h','san_h',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('kiet_dc','kiet_dc',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('nha_mt','nha_mt',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('binh_nh','binh_nh',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('thanh_lt','thanh_lt',8,GETDATE(),GETDATE(),GETDATE(),7,'','','','','')
INSERT INTO ThanhVien VALUES('tien_pv','tien_pv',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('bao_tn','bao_tn',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('phuong_vh','phuong_vh',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('minh_pq','minh_pq',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('phuong_ptt','phuong_ptt',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('cam_nd','cam_nd',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('nhung_ltt','nhung_ltt',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('long_td','long_td',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('hau_nt','hau_nt',8,GETDATE(),GETDATE(),GETDATE(),8,'','','','','')
INSERT INTO ThanhVien VALUES('toan_ld','toan_ld',8,GETDATE(),GETDATE(),GETDATE(),8,'','','','','')
INSERT INTO ThanhVien VALUES('trong_cv','trong_cv',8,GETDATE(),GETDATE(),GETDATE(),8,'','','','','')
INSERT INTO ThanhVien VALUES('thai_tm','thai_tm',8,GETDATE(),GETDATE(),GETDATE(),8,'','','','','')
INSERT INTO ThanhVien VALUES('dung_nt','dung_nt',8,GETDATE(),GETDATE(),GETDATE(),8,'','','','','')
INSERT INTO ThanhVien VALUES('tuan_na','tuan_na',8,GETDATE(),GETDATE(),GETDATE(),8,'','','','','')
INSERT INTO ThanhVien VALUES('minh_tc','minh_tc',8,GETDATE(),GETDATE(),GETDATE(),13,'','','','','')
INSERT INTO ThanhVien VALUES('quoi_vv','quoi_vv',8,GETDATE(),GETDATE(),GETDATE(),13,'','','','','')
INSERT INTO ThanhVien VALUES('tho_pp','tho_pp',8,GETDATE(),GETDATE(),GETDATE(),13,'','','','','')
INSERT INTO ThanhVien VALUES('sang_ntn','sang_ntn',8,GETDATE(),GETDATE(),GETDATE(),13,'','','','','')
INSERT INTO ThanhVien VALUES('vy_nh','vy_nh',8,GETDATE(),GETDATE(),GETDATE(),13,'','','','','')
INSERT INTO ThanhVien VALUES('toan_bx','toan_bx',8,GETDATE(),GETDATE(),GETDATE(),13,'','','','','')
INSERT INTO ThanhVien VALUES('khiem_th','khiem_th',8,GETDATE(),GETDATE(),GETDATE(),13,'','','','','')
INSERT INTO ThanhVien VALUES('hai_nc','hai_nc',8,GETDATE(),GETDATE(),GETDATE(),13,'','','','','')
INSERT INTO ThanhVien VALUES('quan_nv','quan_nv',8,GETDATE(),GETDATE(),GETDATE(),13,'','','','','')
INSERT INTO ThanhVien VALUES('an_hv','an_hv',8,GETDATE(),GETDATE(),GETDATE(),13,'','','','','')
INSERT INTO ThanhVien VALUES('nhan_dh','nhan_dh',8,GETDATE(),GETDATE(),GETDATE(),10,'','','','','')
INSERT INTO ThanhVien VALUES('hong_bv','hong_bv',8,GETDATE(),GETDATE(),GETDATE(),10,'','','','','')
INSERT INTO ThanhVien VALUES('huy_tq','huy_tq',8,GETDATE(),GETDATE(),GETDATE(),10,'','','','','')
INSERT INTO ThanhVien VALUES('trung_lc','trung_lc',8,GETDATE(),GETDATE(),GETDATE(),10,'','','','','')
INSERT INTO ThanhVien VALUES('vinh_vq','vinh_vq',8,GETDATE(),GETDATE(),GETDATE(),10,'','','','','')
INSERT INTO ThanhVien VALUES('quang_nl','quang_nl',8,GETDATE(),GETDATE(),GETDATE(),10,'','','','','')
INSERT INTO ThanhVien VALUES('thong_nv','thong_nv',8,GETDATE(),GETDATE(),GETDATE(),10,'','','','','')
INSERT INTO ThanhVien VALUES('long_nh','long_nh',8,GETDATE(),GETDATE(),GETDATE(),10,'','','','','')
INSERT INTO ThanhVien VALUES('thi_pv','thi_pv',8,GETDATE(),GETDATE(),GETDATE(),9,'','','','','')
INSERT INTO ThanhVien VALUES('ha_nh','ha_nh',8,GETDATE(),GETDATE(),GETDATE(),9,'','','','','')
INSERT INTO ThanhVien VALUES('thong_pq','thong_pq',8,GETDATE(),GETDATE(),GETDATE(),9,'','','','','')
INSERT INTO ThanhVien VALUES('thoai_lh','thoai_lh',8,GETDATE(),GETDATE(),GETDATE(),9,'','','','','')
INSERT INTO ThanhVien VALUES('lan_l','lan_l',8,GETDATE(),GETDATE(),GETDATE(),9,'','','','','')
INSERT INTO ThanhVien VALUES('hue_tv','hue_tv',8,GETDATE(),GETDATE(),GETDATE(),9,'','','','','')
INSERT INTO ThanhVien VALUES('thuy_ln','thuy_ln',8,GETDATE(),GETDATE(),GETDATE(),9,'','','','','')
INSERT INTO ThanhVien VALUES('tung_nt','tung_nt',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('huyen_nt','huyen_nt',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('tham_nth','tham_nth',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')
INSERT INTO ThanhVien VALUES('quynh_lt','quynh_lt',8,GETDATE(),GETDATE(),GETDATE(),6,'','','','','')

-- Table sys_App
Go
INSERT INTO sys_App VALUES('Admin','/HungVuongISO/Admin/Intro.jsp','images/icon/Admin.png',getdate(),'','','','','')
INSERT INTO sys_App VALUES('ISO','/HungVuongISO/ISO/Intro.jsp','images/icon/ISO.png',getdate(),'','','','','')
INSERT INTO sys_App VALUES(N'Điểm Danh','/HungVuongISO/DiemDanh/GiaoVien/LoginDiemDanh.jsp','images/icon/Marks.png',getdate(),'','','','','')
INSERT INTO sys_App VALUES(N'Xem Điểm','','images/icon/TimeSheet.png',getdate(),'','','','','')
INSERT INTO sys_App VALUES(N'Hồi đáp','','images/icon/feedback.png',getdate(),'','','','','')
INSERT INTO sys_App VALUES(N'Báo Cáo','','images/icon/report.png',getdate(),'','','','','')

-- Table sys_Role_App
Go
INSERT INTO sys_Role_App VALUES(0,0,'','','','','')
INSERT INTO sys_Role_App VALUES(0,1,'','','','','')
INSERT INTO sys_Role_App VALUES(0,2,'','','','','')
INSERT INTO sys_Role_App VALUES(0,3,'','','','','')
INSERT INTO sys_Role_App VALUES(0,4,'','','','','')
INSERT INTO sys_Role_App VALUES(0,5,'','','','','')

Go
INSERT INTO sys_Role_App VALUES(1,1,'','','','','')
INSERT INTO sys_Role_App VALUES(1,2,'','','','','')
INSERT INTO sys_Role_App VALUES(1,3,'','','','','')
INSERT INTO sys_Role_App VALUES(1,4,'','','','','')
INSERT INTO sys_Role_App VALUES(1,5,'','','','','')

Go
INSERT INTO sys_Role_App VALUES(2,1,'','','','','')
INSERT INTO sys_Role_App VALUES(2,2,'','','','','')
INSERT INTO sys_Role_App VALUES(2,3,'','','','','')
INSERT INTO sys_Role_App VALUES(2,4,'','','','','')
INSERT INTO sys_Role_App VALUES(2,5,'','','','','')

Go
INSERT INTO sys_Role_App VALUES(3,1,'','','','','')
INSERT INTO sys_Role_App VALUES(3,2,'','','','','')
INSERT INTO sys_Role_App VALUES(3,3,'','','','','')
INSERT INTO sys_Role_App VALUES(3,4,'','','','','')
INSERT INTO sys_Role_App VALUES(3,5,'','','','','')

Go
INSERT INTO sys_Role_App VALUES(4,1,'','','','','')
INSERT INTO sys_Role_App VALUES(4,2,'','','','','')
INSERT INTO sys_Role_App VALUES(4,3,'','','','','')
INSERT INTO sys_Role_App VALUES(4,4,'','','','','')
INSERT INTO sys_Role_App VALUES(4,5,'','','','','')

Go
INSERT INTO sys_Role_App VALUES(5,1,'','','','','')
INSERT INTO sys_Role_App VALUES(5,2,'','','','','')
INSERT INTO sys_Role_App VALUES(5,3,'','','','','')
INSERT INTO sys_Role_App VALUES(5,4,'','','','','')
INSERT INTO sys_Role_App VALUES(5,5,'','','','','')

Go
INSERT INTO sys_Role_App VALUES(6,1,'','','','','')
INSERT INTO sys_Role_App VALUES(6,2,'','','','','')
INSERT INTO sys_Role_App VALUES(6,3,'','','','','')
INSERT INTO sys_Role_App VALUES(6,4,'','','','','')
INSERT INTO sys_Role_App VALUES(6,5,'','','','','')

Go
INSERT INTO sys_Role_App VALUES(7,1,'','','','','')

Go
INSERT INTO sys_Role_App VALUES(8,1,'','','','','')
INSERT INTO sys_Role_App VALUES(8,2,'','','','','')
INSERT INTO sys_Role_App VALUES(8,3,'','','','','')
INSERT INTO sys_Role_App VALUES(8,5,'','','','','')

Go
INSERT INTO sys_Role_App VALUES(10,1,'','','','','')
INSERT INTO sys_Role_App VALUES(10,2,'','','','','')
INSERT INTO sys_Role_App VALUES(10,3,'','','','','')
INSERT INTO sys_Role_App VALUES(10,4,'','','','','')
INSERT INTO sys_Role_App VALUES(10,5,'','','','','')

Go
INSERT INTO sys_Role_App VALUES(11,1,'','','','','')

-- Table sys_Menu (22 cai menu)
Go
INSERT INTO sys_Menu VALUES(1,N'Home','images/icon_menu/home.png','/HungVuongISO/home.jsp','','','','','')
INSERT INTO sys_Menu VALUES(1,N'Intro','images/icon_menu/intro.png','/HungVuongISO/ISO/Intro.jsp','','','','','')
INSERT INTO sys_Menu VALUES(1,N'Kế Hoạch Đào Tạo','images/icon_menu/kehoachdaotao.png','/HungVuongISO/ISO/KeHoachDaoTao/showKeHoachDaoTao.jsp','','','','','')
INSERT INTO sys_Menu VALUES(1,N'Quyết Định Đào Tạo','images/icon_menu/quyetdinhdaotao.png','/HungVuongISO/ISO/QuyetDinhDaoTao/showQuyetDinh.jsp','','','','','')
INSERT INTO sys_Menu VALUES(1,N'Đề Cương Môn Học','images/icon_menu/decuongmonhoc.png','/HungVuongISO/ISO/DeCuongMonHoc/showDeCuong.jsp','','','','','')
INSERT INTO sys_Menu VALUES(1,N'Chương Trình Đào Tạo','images/icon_menu/ctdaotao.png','/HungVuongISO/ISO/ChuongTrinhDaoTao/showChuongTrinhDaoTao.jsp','','','','','')
INSERT INTO sys_Menu VALUES(1,N'Thời Khóa Biểu','images/icon_menu/tkb.png','/HungVuongISO/ISO/ThoiKhoaBieu/showThoiKhoaBieu.jsp','','','','','')
INSERT INTO sys_Menu VALUES(1,N'Kế Hoạch Giảng Dạy','images/icon_menu/kehoach_giangday.png','/HungVuongISO/ISO/KeHoachGiangDay/showKeHoachGiangDay.jsp','','','','','')
INSERT INTO sys_Menu VALUES(1,N'Report','images/icon_menu/report.png','/HungVuongISO/ISO/Report/Report.jsp','','','','','')
INSERT INTO sys_Menu VALUES(1,N'Thêm Công Tác','images/icon_menu/themcongtac.png','/HungVuongISO/ISO/ThemCongTac/ThemCongTac.jsp','','','','','')--them menu congtac
INSERT INTO sys_Menu VALUES(1,N'Phân ca học cho sinh viên','images/icon_menu/phanca.png','/HungVuongISO/ISO/PhanCaHoc/PhanCaHoc.jsp','','','','','')--them menu congtac

Go
INSERT INTO sys_Menu VALUES(0,N'Home','images/icon_menu/home.png','/HungVuongISO/home.jsp','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Thành Viên','images/icon_menu/quanlythanhvien.png','/HungVuongISO/Admin/ThanhVien/ShowThanhVien.jsp?page=1','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Vai Trò','images/icon_menu/quanlyvaitro.png','/HungVuongISO/Admin/VaiTro/ShowVaiTro.jsp','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Khoa_Trung Tâm','images/icon_menu/quanlykhoa.png','/HungVuongISO/Admin/Khoa/ShowKhoa.jsp','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Chuyên Ngành','images/icon_menu/quanlychuyennganh.png','/HungVuongISO/Admin/ChuyenNganh/ShowChuyenNganh.jsp','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Lớp Học','images/icon_menu/quanlylop.png','/HungVuongISO/Admin/Lop/ShowLop.jsp','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Học Phần','images/icon_menu/quanlyhocphan.png','/HungVuongISO/Admin/HocPhan/ShowHocPhan.jsp','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Môn Học','images/icon_menu/quanlymonhoc.png','/HungVuongISO/Admin/MonHoc/ShowMonHoc.jsp','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Phòng Ban','images/icon_menu/quanlyphongban.png','/HungVuongISO/Admin/PhongBan/ShowPhongBan.jsp','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Ứng Dụng','images/icon_menu/quanlyungdung.png','/HungVuongISO/Admin/UngDung/ShowUngDung.jsp','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Menu','images/icon_menu/quanlymenu.png','/HungVuongISO/Admin/UngDung/ShowMenu.jsp','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Thêm Công Tác','images/icon_menu/themcongtac.png','/HungVuongISO/Admin/ThemCongTac/ThemCongTac.jsp','','','','','')
INSERT INTO sys_Menu VALUES(0,N'Xem Tuần Trong Năm','images/icon_menu/tuantrongnam.png','/HungVuongISO/Admin/NamHoc/ShowTuanLe.jsp','','','','','')


-- Table sys_Role_Menu
--SELECT * FROM sys_Role_Menu
/*
ToanTT		0		'Phong Dao Tao'				0	Kế Hoạch Đào Tạo
CuongNQ		1		'Hieu Truong'				1	Quyết Định Đào Tạo
TuanHQ		2		'Phong Hanh Chanh'			2	Đề Cương Môn Học
TaiHC		3		'Truong Khoa'				3	Chương Trình Đào Tạo
QuangLX		4		'Hoi Dong Tham Dinh'		4	Thời Khóa Biểu
DucND		5		'Giao Vien'					5	Kế Hoạch Giảng Dạy
ThienVD		6		'Admin'
TaiNT		7		'Truong Bo Mon'						
*/
--SELECT * FROM sys_Menu

Go
INSERT INTO sys_Role_Menu VALUES(0,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(0,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(0,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(0,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(0,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(0,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(0,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(0,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(0,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(1,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(1,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(1,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(1,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(1,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(1,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(1,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(1,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(1,8,'','','','','')
INSERT INTO sys_Role_Menu VALUES(1,9,'','','','','')--them menu congtac

Go
INSERT INTO sys_Role_Menu VALUES(2,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(2,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(2,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(2,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(2,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(2,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(2,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(2,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(2,8,'','','','','')
INSERT INTO sys_Role_Menu VALUES(2,9,'','','','','')--them menu congtac

Go
INSERT INTO sys_Role_Menu VALUES(3,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(3,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(3,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(3,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(3,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(3,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(3,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(3,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(3,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(4,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(4,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(4,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(4,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(4,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(4,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(4,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(4,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(4,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(5,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(5,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(5,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(5,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(5,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(5,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(5,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(5,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(5,8,'','','','','')


Go
INSERT INTO sys_Role_Menu VALUES(6,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(6,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(6,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(6,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(6,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(6,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(6,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(6,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(6,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(7,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(7,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(7,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(7,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(7,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(7,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(7,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(7,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(7,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(8,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(8,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(8,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(8,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(8,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(8,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(8,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(8,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(8,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(9,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(9,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(9,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(9,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(9,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(9,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(9,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(9,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(9,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(10,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(10,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(10,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(10,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(10,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(10,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(10,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(10,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(10,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(11,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(11,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(11,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(11,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(11,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(11,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(11,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(11,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(11,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(12,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(12,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(12,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(12,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(12,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(12,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(12,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(12,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(12,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(13,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(13,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(13,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(13,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(13,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(13,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(13,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(13,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(13,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(14,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(14,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(14,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(14,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(14,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(14,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(14,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(14,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(14,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(15,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(15,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(15,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(15,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(15,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(15,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(15,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(15,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(15,8,'','','','','')

Go
INSERT INTO sys_Role_Menu VALUES(16,0,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,1,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,2,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,3,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,4,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,5,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,6,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,7,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,8,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,9,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,10,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,11,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,12,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,13,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,14,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,15,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,16,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,17,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,18,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,19,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,20,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,21,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,22,'','','','','')
INSERT INTO sys_Role_Menu VALUES(16,23,'','','','','')--them menu congtac

-- Table HeDaoTao
--SELECT * FROM HeDaoTao
Go
INSERT INTO HeDaoTao VALUES(N'Trung Cấp Nghề',2,'','','','','')
INSERT INTO HeDaoTao VALUES(N'Cao Đẳng Nghề',3,'','','','','')

-- Table Khoa_TrungTam
INSERT INTO Khoa_trungtam VALUES(N'Ban Giám Hiệu', 1,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Phòng Đào Tạo', 4,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Phòng Hành Chánh', 15,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Phòng Công Tác Học Sinh Sinh Viên', 10,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Phòng Đảm Bảo Chất Lượng', 13,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Phòng TCHCQT', 15,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Công Nghệ Thông Tin', 20,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Điện Tử', 21,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Kỹ Thuật Lạnh',26,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Cơ Khí Động Lực', 24,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Cơ Khí Chính Xác', 23,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Lái Xe', 0,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'TT Aptech', 0,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Trung Tâm Cơ Điện tử', 27,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'TT Cắt May - Trang Điểm', 0,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Kế Toán', 0,'' ,0 ,'','','','','','')
INSERT INTO Khoa_trungtam VALUES(N'Admin', 1,'' ,0 ,'','','','','','')

-- Table ChuyenNganh
Go
INSERT INTO ChuyenNganh VALUES(N'Lập trình', 'CNTT_LTV',0 ,GETDATE() ,0,'','','','','','')
INSERT INTO ChuyenNganh VALUES(N'Thiết kế web', 'CNTT_TKW',0 ,GETDATE() ,0,'','','','','','')
INSERT INTO ChuyenNganh VALUES(N'Quản trị mạng', 'CNTT_QTM',0 ,GETDATE() ,0,'','','','','','')
INSERT INTO ChuyenNganh VALUES(N'Điện công nghiệp', 'DT_DCN',0 ,GETDATE() ,0,'','','','','','')
INSERT INTO ChuyenNganh VALUES(N'Cơ khí Ô tô', 'CK_CKOT',0 ,GETDATE() ,0,'','','','','','')
INSERT INTO ChuyenNganh VALUES(N'Lái xe 2 bánh', 'LX_2B',0 ,GETDATE() ,0,'','','','','','')
INSERT INTO ChuyenNganh VALUES(N'Lái xe 4 bánh', 'LX_4B',0 ,GETDATE() ,0,'','','','','','')
INSERT INTO ChuyenNganh VALUES(N'ITT', 'AP_ITT',0 ,GETDATE() ,0,'','','','','','')
INSERT INTO ChuyenNganh VALUES(N'ACCP', 'AP_ACCP',0 ,GETDATE() ,0,'','','','','','')
INSERT INTO ChuyenNganh VALUES(N'May công sở', 'CM_MCS',0 ,GETDATE() ,0,'','','','','','')

-- Table HocPhan
Go
INSERT INTO HocPhan VALUES(N'Môn học chung', '','' ,'','','','','')
INSERT INTO HocPhan VALUES(N'Môn học cơ sở', '','' ,'','','','','')
INSERT INTO HocPhan VALUES(N'Môn học chuyên ngành', '','' ,'','','','','')

-- Table MonHoc
Go
INSERT INTO Monhoc VALUES(N'Quản lý dự án CNTT', 45,30 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Web Java', 40,45 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'EJB', 50,55 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Web PHP', 35,30 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Joomla', 0,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Mạng viễn thông', 30,40 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Wireless', 30,30 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Cơ sở dữ liệu', 30,20 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Kỹ thuật lập trình', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Chính trị', 30,0 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Pháp luật', 15,15 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Giáo dục quốc phòng', 45,10 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Giáo dục thể chất', 30,5 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Anh văn căn bản và chuyên ngành', 80,0 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Kỹ năng giao tiếp', 30,30 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Tin học văn phòng', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Microsoft Access', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Corel Draw', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Lắp ráp cài đặt MT', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Photoshop', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Cấu trúc máy tính', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'CSDL  SQL Server 2005', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Mạng cơ bản', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'HTML-DHTML & Javascript', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Dreamweaver', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Cài đặt và quản trị Windows 2003', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Thiết bị mạng', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Kỹ thuật trình chiếu (Powerpoint)', 20,40 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Internet', 20,40 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Thiết kế Multimedia(FLASH )', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Autocad', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'PHP & MySQL', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Illustrator', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'PHP & MySQL', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Java căn bản hướng đối tượng', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Winform', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Vận hành và duy trì Windows 2003', 40,80 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Mail Server (MS Exchange)', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Thiết kế hệ thống mạng', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Hệ điều hành Linux', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')
INSERT INTO Monhoc VALUES(N'Bảo mật mạng trên Windows ', 30,60 ,'' ,'Thi',1,1,'',0,6,'30','','','','','')



-- Table BangCapDaoTao
Go
INSERT INTO BangCapDaoTao VALUES(N'Hệ Trung Cấp', 0,'','','','','')
INSERT INTO BangCapDaoTao VALUES(N'Hệ Cao Đẳng', 1,'','','','','')

-- Table LopHoc
Go
--INSERT INTO LopHoc VALUES(0,'LT','',1,'','','','','')
--INSERT INTO LopHoc VALUES(1,'TKW','',0,'','','','','')
--INSERT INTO LopHoc VALUES(2,'QTM','',1,'','','','','')

-- Table PhongBan
Go
INSERT INTO PhongBan VALUES('F2.1','','TH',50,'','','','','','')
INSERT INTO PhongBan VALUES('F2.2','','LT',40,'','','','','','')
INSERT INTO PhongBan VALUES('F2.3','','LT',30,'','','','','','')
INSERT INTO PhongBan VALUES('F2.4','','LT',60,'','','','','','')
INSERT INTO PhongBan VALUES(N'Thư Viện','','TH',60,'','','','','','')
INSERT INTO PhongBan VALUES('G2.1','','TH',30,'','','','','','')
INSERT INTO PhongBan VALUES('G2.2','','TH',30,'','','','','','')
INSERT INTO PhongBan VALUES('G2.3','','TH',30,'','','','','','')
INSERT INTO PhongBan VALUES('G2.4','','TH',30,'','','','','','')
INSERT INTO PhongBan VALUES('G2.5','','TH',30,'','','','','','')
INSERT INTO PhongBan VALUES('E2','','LT',80,'','','','','','')

-- Table NamHoc
Go
INSERT INTO namHoc VALUES('2009','2010','','','','','')
INSERT INTO NamHoc VALUES('2010','2011','','','','','')
INSERT INTO namHoc VALUES('2011','2012','','','','','')
INSERT INTO namHoc VALUES('2012','2013','','','','','')
INSERT INTO namHoc VALUES('2013','2014','','','','','')
INSERT INTO namHoc VALUES('2014','2015','','','','','')
INSERT INTO namHoc VALUES('2015','2016','','','','','')

-- Table TuanLe
Go
INSERT INTO TuanLe VALUES('0','1','2009-09-01','2009-09-06','','','','','')
INSERT INTO TuanLe VALUES('0','2','2009-09-07','2009-09-13','','','','','')
INSERT INTO TuanLe VALUES('0','3','2009-09-14','2009-09-20','','','','','')
INSERT INTO TuanLe VALUES('0','4','2009-09-21','2009-09-27','','','','','')
INSERT INTO TuanLe VALUES('0','5','2009-09-28','2009-10-04','','','','','')
INSERT INTO TuanLe VALUES('0','6','2009-10-05','2009-10-11','','','','','')
INSERT INTO TuanLe VALUES('0','7','2009-10-12','2009-10-18','','','','','')
INSERT INTO TuanLe VALUES('0','8','2009-10-19','2009-10-25','','','','','')
INSERT INTO TuanLe VALUES('0','9','2009-10-26','2009-11-01','','','','','')
INSERT INTO TuanLe VALUES('0','10','2009-11-02','2009-11-08','','','','','')
INSERT INTO TuanLe VALUES('0','11','2009-11-09','2009-11-15','','','','','')
INSERT INTO TuanLe VALUES('0','12','2009-11-16','2009-11-22','','','','','')
INSERT INTO TuanLe VALUES('0','13','2009-11-23','2009-11-29','','','','','')
INSERT INTO TuanLe VALUES('0','14','2009-11-30','2009-12-06','','','','','')
INSERT INTO TuanLe VALUES('0','15','2009-12-07','2009-12-13','','','','','')
INSERT INTO TuanLe VALUES('0','16','2009-12-14','2009-12-20','','','','','')
INSERT INTO TuanLe VALUES('0','17','2009-12-21','2009-12-27','','','','','')
INSERT INTO TuanLe VALUES('0','18','2009-12-28','2010-01-03','','','','','')
INSERT INTO TuanLe VALUES('0','19','2010-01-04','2010-01-10','','','','','')
INSERT INTO TuanLe VALUES('0','20','2010-01-11','2010-01-17','','','','','')
INSERT INTO TuanLe VALUES('0','21','2010-01-18','2010-01-24','','','','','')
INSERT INTO TuanLe VALUES('0','22','2010-01-25','2010-01-31','','','','','')
INSERT INTO TuanLe VALUES('0','23','2010-02-01','2010-02-07','','','','','')
INSERT INTO TuanLe VALUES('0','24','2010-02-08','2010-02-14','','','','','')
INSERT INTO TuanLe VALUES('0','25','2010-02-15','2010-02-21','','','','','')
INSERT INTO TuanLe VALUES('0','26','2010-02-22','2010-02-28','','','','','')
INSERT INTO TuanLe VALUES('0','27','2010-03-01','2010-03-07','','','','','')
INSERT INTO TuanLe VALUES('0','28','2010-03-08','2010-03-14','','','','','')
INSERT INTO TuanLe VALUES('0','29','2010-03-15','2010-03-21','','','','','')
INSERT INTO TuanLe VALUES('0','30','2010-03-22','2010-03-28','','','','','')
INSERT INTO TuanLe VALUES('0','31','2010-03-29','2010-04-04','','','','','')
INSERT INTO TuanLe VALUES('0','32','2010-04-05','2010-04-11','','','','','')
INSERT INTO TuanLe VALUES('0','33','2010-04-12','2010-04-18','','','','','')
INSERT INTO TuanLe VALUES('0','34','2010-04-19','2010-04-25','','','','','')
INSERT INTO TuanLe VALUES('0','35','2010-04-26','2010-05-02','','','','','')
INSERT INTO TuanLe VALUES('0','36','2010-05-03','2010-05-09','','','','','')
INSERT INTO TuanLe VALUES('0','37','2010-05-10','2010-05-16','','','','','')
INSERT INTO TuanLe VALUES('0','38','2010-05-17','2010-05-23','','','','','')
INSERT INTO TuanLe VALUES('0','39','2010-05-24','2010-05-30','','','','','')
INSERT INTO TuanLe VALUES('0','40','2010-05-31','2010-06-06','','','','','')
INSERT INTO TuanLe VALUES('0','41','2010-06-07','2010-06-13','','','','','')
INSERT INTO TuanLe VALUES('0','42','2010-06-14','2010-06-20','','','','','')
INSERT INTO TuanLe VALUES('0','43','2010-06-21','2010-06-27','','','','','')
INSERT INTO TuanLe VALUES('0','44','2010-06-28','2010-07-04','','','','','')
INSERT INTO TuanLe VALUES('0','45','2010-07-05','2010-07-11','','','','','')
INSERT INTO TuanLe VALUES('0','46','2010-07-12','2010-07-18','','','','','')
INSERT INTO TuanLe VALUES('0','47','2010-07-19','2010-07-25','','','','','')
INSERT INTO TuanLe VALUES('0','48','2010-07-26','2010-08-01','','','','','')
INSERT INTO TuanLe VALUES('0','49','2010-08-02','2010-08-08','','','','','')
INSERT INTO TuanLe VALUES('0','50','2010-08-09','2010-08-15','','','','','')
INSERT INTO TuanLe VALUES('0','51','2010-08-16','2010-08-22','','','','','')
INSERT INTO TuanLe VALUES('0','51','2010-08-23','2010-08-29','','','','','')

INSERT INTO TuanLe VALUES('1','1','2010-08-30','2010-09-05','','','','','')
INSERT INTO TuanLe VALUES('1','2','2010-09-06','2010-09-12','','','','','')
INSERT INTO TuanLe VALUES('1','3','2010-09-13','2010-09-19','','','','','')
INSERT INTO TuanLe VALUES('1','4','2010-09-20','2010-09-26','','','','','')
INSERT INTO TuanLe VALUES('1','5','2010-09-27','2010-10-03','','','','','')
INSERT INTO TuanLe VALUES('1','6','2010-10-04','2010-10-10','','','','','')
INSERT INTO TuanLe VALUES('1','7','2010-10-11','2010-10-17','','','','','')
INSERT INTO TuanLe VALUES('1','8','2010-10-18','2010-10-24','','','','','')
INSERT INTO TuanLe VALUES('1','9','2010-10-25','2010-10-31','','','','','')
INSERT INTO TuanLe VALUES('1','10','2010-11-01','2010-11-07','','','','','')
INSERT INTO TuanLe VALUES('1','11','2010-11-08','2010-11-14','','','','','')
INSERT INTO TuanLe VALUES('1','12','2010-11-15','2010-11-21','','','','','')
INSERT INTO TuanLe VALUES('1','13','2010-11-22','2010-11-28','','','','','')
INSERT INTO TuanLe VALUES('1','14','2010-11-29','2010-12-05','','','','','')
INSERT INTO TuanLe VALUES('1','15','2010-12-06','2010-12-12','','','','','')
INSERT INTO TuanLe VALUES('1','16','2010-12-13','2010-12-19','','','','','')
INSERT INTO TuanLe VALUES('1','17','2010-12-20','2010-12-26','','','','','')
INSERT INTO TuanLe VALUES('1','18','2010-12-27','2011-01-02','','','','','')
INSERT INTO TuanLe VALUES('1','19','2011-01-03','2011-01-09','','','','','')
INSERT INTO TuanLe VALUES('1','20','2011-01-10','2011-01-16','','','','','')
INSERT INTO TuanLe VALUES('1','21','2011-01-17','2011-01-23','','','','','')
INSERT INTO TuanLe VALUES('1','22','2011-01-24','2011-01-30','','','','','')
INSERT INTO TuanLe VALUES('1','23','2011-01-31','2011-02-06','','','','','')
INSERT INTO TuanLe VALUES('1','24','2011-02-07','2011-02-13','','','','','')
INSERT INTO TuanLe VALUES('1','25','2011-02-14','2011-02-20','','','','','')
INSERT INTO TuanLe VALUES('1','26','2011-02-21','2011-02-27','','','','','')
INSERT INTO TuanLe VALUES('1','27','2011-02-28','2011-03-06','','','','','')
INSERT INTO TuanLe VALUES('1','28','2011-03-07','2011-03-13','','','','','')
INSERT INTO TuanLe VALUES('1','29','2011-03-14','2011-03-20','','','','','')
INSERT INTO TuanLe VALUES('1','30','2011-03-21','2011-03-27','','','','','')
INSERT INTO TuanLe VALUES('1','31','2011-03-28','2011-04-03','','','','','')
INSERT INTO TuanLe VALUES('1','32','2011-04-04','2011-04-10','','','','','')
INSERT INTO TuanLe VALUES('1','33','2011-04-11','2011-04-17','','','','','')
INSERT INTO TuanLe VALUES('1','34','2011-04-18','2011-04-24','','','','','')
INSERT INTO TuanLe VALUES('1','35','2011-04-25','2011-05-01','','','','','')
INSERT INTO TuanLe VALUES('1','36','2011-05-02','2011-05-08','','','','','')
INSERT INTO TuanLe VALUES('1','37','2011-05-09','2011-05-15','','','','','')
INSERT INTO TuanLe VALUES('1','38','2011-05-16','2011-05-22','','','','','')
INSERT INTO TuanLe VALUES('1','39','2011-05-23','2011-05-29','','','','','')
INSERT INTO TuanLe VALUES('1','40','2011-05-30','2011-06-05','','','','','')
INSERT INTO TuanLe VALUES('1','41','2011-06-06','2011-06-12','','','','','')
INSERT INTO TuanLe VALUES('1','42','2011-06-13','2011-06-19','','','','','')
INSERT INTO TuanLe VALUES('1','43','2011-06-20','2011-06-26','','','','','')
INSERT INTO TuanLe VALUES('1','44','2011-06-27','2011-07-03','','','','','')
INSERT INTO TuanLe VALUES('1','45','2011-07-04','2011-07-10','','','','','')
INSERT INTO TuanLe VALUES('1','46','2011-07-11','2011-07-17','','','','','')
INSERT INTO TuanLe VALUES('1','47','2011-07-18','2011-07-24','','','','','')
INSERT INTO TuanLe VALUES('1','48','2011-07-25','2011-07-31','','','','','')
INSERT INTO TuanLe VALUES('1','49','2011-08-01','2011-08-07','','','','','')
INSERT INTO TuanLe VALUES('1','50','2011-08-08','2011-08-14','','','','','')
INSERT INTO TuanLe VALUES('1','51','2011-08-15','2011-08-21','','','','','')
INSERT INTO TuanLe VALUES('1','52','2011-08-22','2011-08-28','','','','','')

INSERT INTO TuanLe VALUES('2','1','2011-09-01','2011-09-04','','','','','')
INSERT INTO TuanLe VALUES('2','2','2011-09-05','2011-09-11','','','','','')
INSERT INTO TuanLe VALUES('2','3','2011-09-12','2011-09-18','','','','','')
INSERT INTO TuanLe VALUES('2','4','2011-09-19','2011-09-25','','','','','')
INSERT INTO TuanLe VALUES('2','5','2011-09-26','2011-10-02','','','','','')
INSERT INTO TuanLe VALUES('2','6','2011-10-03','2011-10-09','','','','','')
INSERT INTO TuanLe VALUES('2','7','2011-10-10','2011-10-16','','','','','')
INSERT INTO TuanLe VALUES('2','8','2011-10-17','2011-10-23','','','','','')
INSERT INTO TuanLe VALUES('2','9','2011-10-24','2011-10-30','','','','','')
INSERT INTO TuanLe VALUES('2','10','2011-10-31','2011-11-06','','','','','')
INSERT INTO TuanLe VALUES('2','11','2011-11-07','2011-11-13','','','','','')
INSERT INTO TuanLe VALUES('2','12','2011-11-14','2011-11-20','','','','','')
INSERT INTO TuanLe VALUES('2','13','2011-11-21','2011-11-27','','','','','')
INSERT INTO TuanLe VALUES('2','14','2011-11-28','2011-12-04','','','','','')
INSERT INTO TuanLe VALUES('2','15','2011-12-05','2011-12-11','','','','','')
INSERT INTO TuanLe VALUES('2','16','2011-12-12','2011-12-18','','','','','')
INSERT INTO TuanLe VALUES('2','17','2011-12-19','2011-12-25','','','','','')
INSERT INTO TuanLe VALUES('2','18','2011-12-26','2012-01-01','','','','','')
INSERT INTO TuanLe VALUES('2','19','2012-01-02','2012-01-08','','','','','')
INSERT INTO TuanLe VALUES('2','20','2012-01-09','2012-01-15','','','','','')
INSERT INTO TuanLe VALUES('2','21','2012-01-16','2012-01-22','','','','','')
INSERT INTO TuanLe VALUES('2','22','2012-01-23','2012-01-29','','','','','')
INSERT INTO TuanLe VALUES('2','23','2012-01-30','2012-02-05','','','','','')
INSERT INTO TuanLe VALUES('2','24','2012-02-06','2012-02-12','','','','','')
INSERT INTO TuanLe VALUES('2','25','2012-02-13','2012-02-19','','','','','')
INSERT INTO TuanLe VALUES('2','26','2012-02-20','2012-02-26','','','','','')
INSERT INTO TuanLe VALUES('2','27','2012-02-27','2012-03-04','','','','','')
INSERT INTO TuanLe VALUES('2','28','2012-03-05','2012-03-11','','','','','')
INSERT INTO TuanLe VALUES('2','29','2012-03-12','2012-03-18','','','','','')
INSERT INTO TuanLe VALUES('2','30','2012-03-19','2012-03-25','','','','','')
INSERT INTO TuanLe VALUES('2','31','2012-03-26','2012-04-01','','','','','')
INSERT INTO TuanLe VALUES('2','32','2012-04-02','2012-04-08','','','','','')
INSERT INTO TuanLe VALUES('2','33','2012-04-09','2012-04-15','','','','','')
INSERT INTO TuanLe VALUES('2','34','2012-04-16','2012-04-22','','','','','')
INSERT INTO TuanLe VALUES('2','35','2012-04-23','2012-04-29','','','','','')
INSERT INTO TuanLe VALUES('2','36','2012-04-30','2012-05-06','','','','','')
INSERT INTO TuanLe VALUES('2','37','2012-05-07','2012-05-13','','','','','')
INSERT INTO TuanLe VALUES('2','38','2012-05-14','2012-05-20','','','','','')
INSERT INTO TuanLe VALUES('2','39','2012-05-21','2012-05-27','','','','','')
INSERT INTO TuanLe VALUES('2','40','2012-05-28','2012-06-03','','','','','')
INSERT INTO TuanLe VALUES('2','41','2012-06-04','2012-06-10','','','','','')
INSERT INTO TuanLe VALUES('2','42','2012-06-11','2012-06-17','','','','','')
INSERT INTO TuanLe VALUES('2','43','2012-06-18','2012-06-24','','','','','')
INSERT INTO TuanLe VALUES('2','44','2012-06-25','2012-07-01','','','','','')
INSERT INTO TuanLe VALUES('2','45','2012-07-02','2012-07-08','','','','','')
INSERT INTO TuanLe VALUES('2','46','2012-07-09','2012-07-15','','','','','')
INSERT INTO TuanLe VALUES('2','47','2012-07-16','2012-07-22','','','','','')
INSERT INTO TuanLe VALUES('2','48','2012-07-23','2012-07-29','','','','','')
INSERT INTO TuanLe VALUES('2','49','2012-07-30','2012-08-05','','','','','')
INSERT INTO TuanLe VALUES('2','50','2012-08-06','2012-08-12','','','','','')
INSERT INTO TuanLe VALUES('2','51','2012-08-13','2012-08-19','','','','','')
INSERT INTO TuanLe VALUES('2','52','2012-08-20','2012-08-26','','','','','')

INSERT INTO TuanLe VALUES('3','1','2012-09-03','2012-09-09','','','','','')
INSERT INTO TuanLe VALUES('3','2','2012-09-10','2012-09-16','','','','','')
INSERT INTO TuanLe VALUES('3','3','2012-09-17','2012-09-23','','','','','')
INSERT INTO TuanLe VALUES('3','4','2012-09-24','2012-09-30','','','','','')
INSERT INTO TuanLe VALUES('3','5','2012-10-01','2012-10-07','','','','','')
INSERT INTO TuanLe VALUES('3','6','2012-10-08','2012-10-14','','','','','')
INSERT INTO TuanLe VALUES('3','7','2012-10-15','2012-10-21','','','','','')
INSERT INTO TuanLe VALUES('3','8','2012-10-22','2012-10-28','','','','','')
INSERT INTO TuanLe VALUES('3','9','2012-10-29','2012-11-04','','','','','')
INSERT INTO TuanLe VALUES('3','10','2012-11-05','2012-11-11','','','','','')
INSERT INTO TuanLe VALUES('3','11','2012-11-12','2012-11-18','','','','','')
INSERT INTO TuanLe VALUES('3','12','2012-11-19','2012-11-25','','','','','')
INSERT INTO TuanLe VALUES('3','13','2012-11-26','2012-12-02','','','','','')
INSERT INTO TuanLe VALUES('3','14','2012-12-03','2012-12-09','','','','','')
INSERT INTO TuanLe VALUES('3','15','2012-12-10','2012-12-16','','','','','')
INSERT INTO TuanLe VALUES('3','16','2012-12-17','2012-12-23','','','','','')
INSERT INTO TuanLe VALUES('3','17','2012-12-24','2012-12-30','','','','','')
INSERT INTO TuanLe VALUES('3','18','2012-12-31','2013-01-06','','','','','')
INSERT INTO TuanLe VALUES('3','19','2013-01-07','2013-01-13','','','','','')
INSERT INTO TuanLe VALUES('3','20','2013-01-14','2013-01-20','','','','','')
INSERT INTO TuanLe VALUES('3','21','2013-01-21','2013-01-27','','','','','')
INSERT INTO TuanLe VALUES('3','22','2013-01-28','2013-02-03','','','','','')
INSERT INTO TuanLe VALUES('3','23','2013-02-04','2013-02-10','','','','','')
INSERT INTO TuanLe VALUES('3','24','2013-02-11','2013-02-17','','','','','')
INSERT INTO TuanLe VALUES('3','25','2013-02-18','2013-02-24','','','','','')
INSERT INTO TuanLe VALUES('3','26','2013-02-25','2013-03-03','','','','','')
INSERT INTO TuanLe VALUES('3','27','2013-03-04','2013-03-10','','','','','')
INSERT INTO TuanLe VALUES('3','28','2013-03-11','2013-03-17','','','','','')
INSERT INTO TuanLe VALUES('3','29','2013-03-18','2013-03-24','','','','','')
INSERT INTO TuanLe VALUES('3','30','2013-03-25','2013-03-31','','','','','')
INSERT INTO TuanLe VALUES('3','31','2013-04-01','2013-04-07','','','','','')
INSERT INTO TuanLe VALUES('3','32','2013-04-08','2013-04-14','','','','','')
INSERT INTO TuanLe VALUES('3','33','2013-04-15','2013-04-21','','','','','')
INSERT INTO TuanLe VALUES('3','34','2013-04-22','2013-04-28','','','','','')
INSERT INTO TuanLe VALUES('3','35','2013-04-29','2013-05-05','','','','','')
INSERT INTO TuanLe VALUES('3','36','2013-04-06','2013-05-12','','','','','')
INSERT INTO TuanLe VALUES('3','37','2013-05-13','2013-05-19','','','','','')
INSERT INTO TuanLe VALUES('3','38','2013-05-20','2013-05-26','','','','','')
INSERT INTO TuanLe VALUES('3','39','2013-05-27','2013-06-02','','','','','')
INSERT INTO TuanLe VALUES('3','40','2013-06-03','2013-06-09','','','','','')
INSERT INTO TuanLe VALUES('3','41','2013-06-10','2013-06-16','','','','','')
INSERT INTO TuanLe VALUES('3','42','2013-06-17','2013-06-23','','','','','')
INSERT INTO TuanLe VALUES('3','43','2013-06-24','2013-06-30','','','','','')
INSERT INTO TuanLe VALUES('3','44','2013-07-01','2013-07-07','','','','','')
INSERT INTO TuanLe VALUES('3','45','2013-07-08','2013-07-14','','','','','')
INSERT INTO TuanLe VALUES('3','46','2013-07-15','2013-07-21','','','','','')
INSERT INTO TuanLe VALUES('3','47','2013-07-22','2013-07-28','','','','','')
INSERT INTO TuanLe VALUES('3','48','2013-07-22','2013-07-28','','','','','')
INSERT INTO TuanLe VALUES('3','49','2013-07-29','2013-08-04','','','','','')
INSERT INTO TuanLe VALUES('3','50','2013-08-05','2013-08-11','','','','','')
INSERT INTO TuanLe VALUES('3','51','2013-08-12','2013-08-18','','','','','')
INSERT INTO TuanLe VALUES('3','52','2013-08-19','2013-08-25','','','','','')

INSERT INTO TuanLe VALUES('4','1','2013-09-02','2013-09-08','','','','','')
INSERT INTO TuanLe VALUES('4','2','2013-09-09','2013-09-15','','','','','')
INSERT INTO TuanLe VALUES('4','3','2013-09-16','2013-09-22','','','','','')
INSERT INTO TuanLe VALUES('4','4','2013-09-23','2013-09-29','','','','','')
INSERT INTO TuanLe VALUES('4','5','2013-09-30','2013-10-06','','','','','')
INSERT INTO TuanLe VALUES('4','6','2013-10-07','2013-10-13','','','','','')
INSERT INTO TuanLe VALUES('4','7','2013-10-14','2013-10-20','','','','','')
INSERT INTO TuanLe VALUES('4','8','2013-10-21','2013-10-27','','','','','')
INSERT INTO TuanLe VALUES('4','9','2013-10-28','2013-11-03','','','','','')
INSERT INTO TuanLe VALUES('4','10','2013-11-04','2013-11-10','','','','','')
INSERT INTO TuanLe VALUES('4','11','2013-11-11','2013-11-17','','','','','')
INSERT INTO TuanLe VALUES('4','12','2013-11-18','2013-11-24','','','','','')
INSERT INTO TuanLe VALUES('4','13','2013-11-25','2013-12-01','','','','','')
INSERT INTO TuanLe VALUES('4','14','2013-12-02','2013-12-08','','','','','')
INSERT INTO TuanLe VALUES('4','15','2013-12-09','2013-12-15','','','','','')
INSERT INTO TuanLe VALUES('4','16','2013-12-16','2013-12-22','','','','','')
INSERT INTO TuanLe VALUES('4','17','2013-12-23','2013-12-29','','','','','')
INSERT INTO TuanLe VALUES('4','18','2013-12-30','2014-01-05','','','','','')
INSERT INTO TuanLe VALUES('4','19','2014-01-06','2014-01-12','','','','','')
INSERT INTO TuanLe VALUES('4','20','2014-01-13','2014-01-19','','','','','')
INSERT INTO TuanLe VALUES('4','21','2014-01-20','2014-01-26','','','','','')
INSERT INTO TuanLe VALUES('4','22','2014-01-27','2014-02-02','','','','','')
INSERT INTO TuanLe VALUES('4','23','2014-02-03','2014-02-09','','','','','')
INSERT INTO TuanLe VALUES('4','24','2014-02-10','2014-02-16','','','','','')
INSERT INTO TuanLe VALUES('4','25','2014-02-17','2014-02-23','','','','','')
INSERT INTO TuanLe VALUES('4','26','2014-02-24','2014-03-02','','','','','')
INSERT INTO TuanLe VALUES('4','27','2014-03-03','2014-03-09','','','','','')
INSERT INTO TuanLe VALUES('4','28','2014-03-10','2014-03-16','','','','','')
INSERT INTO TuanLe VALUES('4','29','2014-03-17','2014-03-23','','','','','')
INSERT INTO TuanLe VALUES('4','30','2014-03-24','2014-03-30','','','','','')
INSERT INTO TuanLe VALUES('4','31','2014-03-31','2014-04-06','','','','','')
INSERT INTO TuanLe VALUES('4','32','2014-04-07','2014-04-13','','','','','')
INSERT INTO TuanLe VALUES('4','33','2014-04-14','2014-04-20','','','','','')
INSERT INTO TuanLe VALUES('4','34','2014-04-21','2014-04-27','','','','','')
INSERT INTO TuanLe VALUES('4','35','2014-04-28','2014-05-04','','','','','')
INSERT INTO TuanLe VALUES('4','36','2014-05-05','2014-05-11','','','','','')
INSERT INTO TuanLe VALUES('4','37','2014-05-12','2014-05-18','','','','','')
INSERT INTO TuanLe VALUES('4','38','2014-05-19','2014-05-25','','','','','')
INSERT INTO TuanLe VALUES('4','39','2014-05-26','2014-06-01','','','','','')
INSERT INTO TuanLe VALUES('4','40','2014-06-02','2014-06-08','','','','','')
INSERT INTO TuanLe VALUES('4','41','2014-06-09','2014-06-15','','','','','')
INSERT INTO TuanLe VALUES('4','42','2014-06-16','2014-06-22','','','','','')
INSERT INTO TuanLe VALUES('4','43','2014-06-23','2014-06-29','','','','','')
INSERT INTO TuanLe VALUES('4','44','2014-06-30','2014-07-06','','','','','')
INSERT INTO TuanLe VALUES('4','45','2014-07-07','2014-07-13','','','','','')
INSERT INTO TuanLe VALUES('4','46','2014-07-14','2014-07-20','','','','','')
INSERT INTO TuanLe VALUES('4','47','2014-07-21','2014-07-27','','','','','')
INSERT INTO TuanLe VALUES('4','48','2014-07-28','2014-08-03','','','','','')
INSERT INTO TuanLe VALUES('4','49','2014-08-04','2014-08-10','','','','','')
INSERT INTO TuanLe VALUES('4','50','2014-08-11','2014-08-17','','','','','')
INSERT INTO TuanLe VALUES('4','51','2014-08-18','2014-08-24','','','','','')
INSERT INTO TuanLe VALUES('4','52','2014-08-25','2014-08-31','','','','','')

INSERT INTO TuanLe VALUES('5','1','2014-09-01','2014-09-07','','','','','')
INSERT INTO TuanLe VALUES('5','2','2014-09-08','2014-09-14','','','','','')
INSERT INTO TuanLe VALUES('5','3','2014-09-15','2014-09-21','','','','','')
INSERT INTO TuanLe VALUES('5','4','2014-09-22','2014-09-28','','','','','')
INSERT INTO TuanLe VALUES('5','5','2014-09-29','2014-10-05','','','','','')
INSERT INTO TuanLe VALUES('5','6','2014-10-06','2014-10-12','','','','','')
INSERT INTO TuanLe VALUES('5','7','2014-10-13','2014-10-19','','','','','')
INSERT INTO TuanLe VALUES('5','8','2014-10-20','2014-10-26','','','','','')
INSERT INTO TuanLe VALUES('5','9','2014-10-27','2014-11-02','','','','','')
INSERT INTO TuanLe VALUES('5','10','2014-11-03','2014-11-09','','','','','')
INSERT INTO TuanLe VALUES('5','11','2014-11-10','2014-11-16','','','','','')
INSERT INTO TuanLe VALUES('5','12','2014-11-17','2014-11-23','','','','','')
INSERT INTO TuanLe VALUES('5','13','2014-11-24','2014-11-30','','','','','')
INSERT INTO TuanLe VALUES('5','14','2014-12-01','2014-12-07','','','','','')
INSERT INTO TuanLe VALUES('5','15','2014-12-08','2014-12-14','','','','','')
INSERT INTO TuanLe VALUES('5','16','2014-12-15','2014-12-21','','','','','')
INSERT INTO TuanLe VALUES('5','17','2014-12-22','2014-12-28','','','','','')
INSERT INTO TuanLe VALUES('5','18','2014-12-29','2015-01-04','','','','','')
INSERT INTO TuanLe VALUES('5','19','2015-01-05','2015-01-11','','','','','')
INSERT INTO TuanLe VALUES('5','20','2015-01-12','2015-01-18','','','','','')
INSERT INTO TuanLe VALUES('5','21','2015-01-19','2015-01-25','','','','','')
INSERT INTO TuanLe VALUES('5','22','2015-01-26','2015-02-01','','','','','')
INSERT INTO TuanLe VALUES('5','23','2015-02-02','2015-02-08','','','','','')
INSERT INTO TuanLe VALUES('5','24','2015-02-09','2015-02-15','','','','','')
INSERT INTO TuanLe VALUES('5','25','2015-02-16','2015-02-22','','','','','')
INSERT INTO TuanLe VALUES('5','26','2015-02-23','2015-03-01','','','','','')
INSERT INTO TuanLe VALUES('5','27','2015-03-02','2015-03-08','','','','','')
INSERT INTO TuanLe VALUES('5','28','2015-03-09','2015-03-15','','','','','')
INSERT INTO TuanLe VALUES('5','29','2015-03-16','2015-03-22','','','','','')
INSERT INTO TuanLe VALUES('5','30','2015-03-23','2015-03-29','','','','','')
INSERT INTO TuanLe VALUES('5','31','2015-03-30','2015-04-05','','','','','')
INSERT INTO TuanLe VALUES('5','32','2015-04-06','2015-04-12','','','','','')
INSERT INTO TuanLe VALUES('5','33','2015-04-13','2015-04-19','','','','','')
INSERT INTO TuanLe VALUES('5','34','2015-04-20','2015-04-26','','','','','')
INSERT INTO TuanLe VALUES('5','35','2015-04-27','2015-05-03','','','','','')
INSERT INTO TuanLe VALUES('5','36','2015-05-04','2015-05-10','','','','','')
INSERT INTO TuanLe VALUES('5','37','2015-05-11','2015-05-17','','','','','')
INSERT INTO TuanLe VALUES('5','38','2015-05-18','2015-05-24','','','','','')
INSERT INTO TuanLe VALUES('5','39','2015-05-25','2015-05-31','','','','','')
INSERT INTO TuanLe VALUES('5','40','2015-06-01','2015-06-07','','','','','')
INSERT INTO TuanLe VALUES('5','41','2015-06-08','2015-06-14','','','','','')
INSERT INTO TuanLe VALUES('5','42','2015-06-15','2015-06-21','','','','','')
INSERT INTO TuanLe VALUES('5','43','2015-06-22','2015-06-28','','','','','')
INSERT INTO TuanLe VALUES('5','44','2015-06-29','2015-07-05','','','','','')
INSERT INTO TuanLe VALUES('5','45','2015-07-06','2015-07-12','','','','','')
INSERT INTO TuanLe VALUES('5','46','2015-07-13','2015-07-19','','','','','')
INSERT INTO TuanLe VALUES('5','47','2015-07-20','2015-07-26','','','','','')
INSERT INTO TuanLe VALUES('5','48','2015-07-27','2015-08-02','','','','','')
INSERT INTO TuanLe VALUES('5','49','2015-08-03','2015-08-09','','','','','')
INSERT INTO TuanLe VALUES('5','50','2015-08-10','2015-08-16','','','','','')
INSERT INTO TuanLe VALUES('5','51','2015-08-17','2015-08-23','','','','','')
INSERT INTO TuanLe VALUES('5','52','2015-08-24','2015-08-30','','','','','')

INSERT INTO TuanLe VALUES('6','1','2015-09-01','2015-09-06','','','','','')
INSERT INTO TuanLe VALUES('6','2','2015-09-07','2015-09-13','','','','','')
INSERT INTO TuanLe VALUES('6','3','2015-09-14','2015-09-20','','','','','')
INSERT INTO TuanLe VALUES('6','4','2015-09-21','2015-09-27','','','','','')
INSERT INTO TuanLe VALUES('6','5','2015-09-28','2015-10-04','','','','','')
INSERT INTO TuanLe VALUES('6','6','2015-10-05','2015-10-11','','','','','')
INSERT INTO TuanLe VALUES('6','7','2015-10-12','2015-10-18','','','','','')
INSERT INTO TuanLe VALUES('6','8','2015-10-19','2015-10-25','','','','','')
INSERT INTO TuanLe VALUES('6','9','2015-10-26','2015-11-01','','','','','')
INSERT INTO TuanLe VALUES('6','10','2015-11-02','2015-11-08','','','','','')
INSERT INTO TuanLe VALUES('6','11','2015-11-09','2015-11-15','','','','','')
INSERT INTO TuanLe VALUES('6','12','2015-11-16','2015-11-22','','','','','')
INSERT INTO TuanLe VALUES('6','13','2015-11-23','2015-11-29','','','','','')
INSERT INTO TuanLe VALUES('6','14','2015-12-30','2015-12-06','','','','','')
INSERT INTO TuanLe VALUES('6','15','2015-12-07','2015-12-13','','','','','')
INSERT INTO TuanLe VALUES('6','16','2015-12-14','2015-12-20','','','','','')
INSERT INTO TuanLe VALUES('6','17','2015-12-21','2015-12-27','','','','','')
INSERT INTO TuanLe VALUES('6','18','2015-12-28','2016-01-03','','','','','')
INSERT INTO TuanLe VALUES('6','19','2016-01-04','2016-01-10','','','','','')
INSERT INTO TuanLe VALUES('6','20','2016-01-11','2016-01-17','','','','','')
INSERT INTO TuanLe VALUES('6','21','2016-01-18','2016-01-24','','','','','')
INSERT INTO TuanLe VALUES('6','22','2016-01-25','2016-01-31','','','','','')
INSERT INTO TuanLe VALUES('6','23','2016-02-01','2016-02-07','','','','','')
INSERT INTO TuanLe VALUES('6','24','2016-02-08','2016-02-14','','','','','')
INSERT INTO TuanLe VALUES('6','25','2016-02-15','2016-02-21','','','','','')
INSERT INTO TuanLe VALUES('6','26','2016-02-22','2016-02-28','','','','','')
INSERT INTO TuanLe VALUES('6','27','2016-02-29','2016-03-06','','','','','')
INSERT INTO TuanLe VALUES('6','28','2016-03-07','2016-03-13','','','','','')
INSERT INTO TuanLe VALUES('6','29','2016-03-14','2016-03-20','','','','','')
INSERT INTO TuanLe VALUES('6','30','2016-03-21','2016-03-27','','','','','')
INSERT INTO TuanLe VALUES('6','31','2016-03-28','2016-04-03','','','','','')
INSERT INTO TuanLe VALUES('6','32','2016-04-04','2016-04-10','','','','','')
INSERT INTO TuanLe VALUES('6','33','2016-04-11','2016-04-17','','','','','')
INSERT INTO TuanLe VALUES('6','34','2016-04-18','2016-04-24','','','','','')
INSERT INTO TuanLe VALUES('6','35','2016-04-25','2016-05-01','','','','','')
INSERT INTO TuanLe VALUES('6','36','2016-05-02','2016-05-08','','','','','')
INSERT INTO TuanLe VALUES('6','37','2016-05-09','2016-05-15','','','','','')
INSERT INTO TuanLe VALUES('6','38','2016-05-16','2016-05-22','','','','','')
INSERT INTO TuanLe VALUES('6','39','2016-05-23','2016-05-29','','','','','')
INSERT INTO TuanLe VALUES('6','40','2016-05-30','2016-06-05','','','','','')
INSERT INTO TuanLe VALUES('6','41','2016-06-06','2016-06-12','','','','','')
INSERT INTO TuanLe VALUES('6','42','2016-06-13','2016-06-19','','','','','')
INSERT INTO TuanLe VALUES('6','43','2016-06-20','2016-06-26','','','','','')
INSERT INTO TuanLe VALUES('6','44','2016-06-27','2016-07-03','','','','','')
INSERT INTO TuanLe VALUES('6','45','2016-07-04','2016-07-10','','','','','')
INSERT INTO TuanLe VALUES('6','46','2016-07-11','2016-07-17','','','','','')
INSERT INTO TuanLe VALUES('6','47','2016-07-18','2016-07-24','','','','','')
INSERT INTO TuanLe VALUES('6','48','2016-07-25','2016-07-31','','','','','')
INSERT INTO TuanLe VALUES('6','49','2016-08-01','2016-08-07','','','','','')
INSERT INTO TuanLe VALUES('6','50','2016-08-08','2016-08-14','','','','','')
INSERT INTO TuanLe VALUES('6','51','2016-08-15','2016-08-21','','','','','')
INSERT INTO TuanLe VALUES('6','52','2016-08-22','2016-08-28','','','','','')

-- Table CongTac
GO
INSERT INTO CongTac Values(N'Lập kế họach đào tạo','','','','','','')
INSERT INTO CongTac Values(N'Chuẩn bị hồ sơ ( sổ lên lớp, phiếu kê giờ, phiếu kế hoạch giảng dạy, giáo án, sổ tay giáo viên…)','','','','','','')
INSERT INTO CongTac Values(N'Tiến độ đào tạo','','','','','','')
INSERT INTO CongTac Values(N'Tổng hợp kế hoạch phân công giáo viên','','','','','','')
INSERT INTO CongTac Values(N'Hợp đồng giảng dạy giáo viên','','','','','','')
INSERT INTO CongTac Values(N'Lập thời khóa biểu','','','','','','')
INSERT INTO CongTac Values(N'Tổng hợp bảng điểm ; danh sách học sinh nợ môn','','','','','','')
INSERT INTO CongTac Values(N'Biên sọan giáo án, kế họach giảng dạy lý thuyết, thực hành, đề cương chi tiết môn học theo TKB','','','','','','')
INSERT INTO CongTac Values(N'Phân công tổ quản lý học sinh kiểm tra sổ đầu bài, theo dõi tiến độ giảng dạy','','','','','','')
INSERT INTO CongTac Values(N'Họp hội đồng tuyển sinh. Phát giấy báo trúng tuyển đợt 1','','','','','','')
INSERT INTO CongTac Values(N'Tập huấn kỹ năng biên sọan giáo án tích hợp','','','','','','')
INSERT INTO CongTac Values(N'Kế họach bồi dưỡng kỹ năng mềm','','','','','','')
INSERT INTO CongTac Values(N'Kế hoạch ôn tập môn Toán, Lý, phương pháp tư duy khoa học','','','','','','')
INSERT INTO CongTac Values(N'Lập kế hoạch kiểm tra đầu vào tin học, ngoại ngữ cho học sinh ngành CNTT','','','','','','')
INSERT INTO CongTac Values(N'Kế họach sinh hoạt ngoại khóa tòan trường','','','','','','')
INSERT INTO CongTac Values(N'Lv giáo viên Anh văn chuẩn bị kế hoạch đào tạo Anh văn theo chuẩn TOEIC cho các nghề ĐCN, CĐT, VHSCTB lạnh, ĐTCN','','','','','','')
INSERT INTO CongTac Values(N'Tổng hợp chương trình đào tạo','','','','','','')
INSERT INTO CongTac Values(N'Học sinh học theo TKB','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra kế hoạch giảng dạy lý thuyết, thực hành; đề cương chương trình môn học','','','','','','')
INSERT INTO CongTac Values(N'Danh sách học sinh học bổng ','','','','','','')
INSERT INTO CongTac Values(N'Chuẩn bị danh sách thi lại + đề thi HK ','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra số học sinh học thực tế đầu HK','','','','','','')
INSERT INTO CongTac Values(N'Kế họach dự giờ giáo viên','','','','','','')
INSERT INTO CongTac Values(N'Chuẩn bị nội dung sinh hoạt ngoại khóa (các slide trình chiếu, tóm tắt nội qui, qui chế thi, phiếu khảo sát học sinh hệ TCN đầu khóa)','','','','','','')
INSERT INTO CongTac Values(N'Họp giáo viên chủ nhiệm, BCS lớp ổn định tình hình học tập đầu năm, thông qua danh sách học bổng','','','','','','')
INSERT INTO CongTac Values(N'Phổ biến thông tin thi đại học khối K, liên thông cao đẳng nghề','','','','','','')
INSERT INTO CongTac Values(N'Hòan tất qui trình ISO','','','','','','')
INSERT INTO CongTac Values(N'Ôn tập Toán, Lý, tư duy khoa học và tổ chức sinh hoạt ngoại khóa','','','','','','')
INSERT INTO CongTac Values(N'Phát động phong trào thi đua học tốt trong đoàn viên thanh niên','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra tiến độ giảng dạy','','','','','','')
INSERT INTO CongTac Values(N'Dự giờ giáo viên theo kế họach','','','','','','')
INSERT INTO CongTac Values(N'Hoàn thành TKB ','','','','','','')
INSERT INTO CongTac Values(N'Biên sọan đề cương chi tiết môn học, kế hoạch giảng dạy, giáo án, phiếu HDTH','','','','','','')
INSERT INTO CongTac Values(N'Khám sức khoẻ học sinh trúng tuyển đợt 1','','','','','','')
INSERT INTO CongTac Values(N'Thi lại','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra tin học, ngọai ngữ đầu vào khoa CNTT','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra công tác chuẩn bị tại các khoa (tài liệu giảng dạy, cơ sở vật chất: các phòng thực hành CNTT, ĐTCN)','','','','','','')
INSERT INTO CongTac Values(N'Phân lớp theo danh sách học sinh trúng tuyển','','','','','','')
INSERT INTO CongTac Values(N'Niêm yết danh sách lớp và điều chỉnh ngành học cho học sinh','','','','','','')
INSERT INTO CongTac Values(N'Niêm yết thời khóa biểu','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra buổi học thực hành của học sinh','','','','','','')
INSERT INTO CongTac Values(N'Thống kê số liệu học sinh nghỉ học','','','','','','')
INSERT INTO CongTac Values(N'Họp giáo viên chủ nhiệm, ban cán sự lớp','','','','','','')
INSERT INTO CongTac Values(N'Khám sức khỏe học sinh trúng tuyển đợt 2','','','','','','')
INSERT INTO CongTac Values(N'Tổ chức ôn luyện học sinh tham gia hội thi tay nghề ASEAN','','','','','','')
INSERT INTO CongTac Values(N'Khai giảng năm học ','','','','','','')
INSERT INTO CongTac Values(N'Thăm dò ý kiến học sinh','','','','','','')
INSERT INTO CongTac Values(N'Phát bằng tốt nghiệp học sinh','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra công tác chuẩn bị lên lớp (đề cương môn học, kế hoạch giảng dạy, phiếu HDTH…)','','','','','','')
INSERT INTO CongTac Values(N'Thực hiện thăm dò ý kiến học sinh/ môn học','','','','','','')
INSERT INTO CongTac Values(N'Kế hoạch hoạt động văn – thể – mỹ chào mừng ngày Nhà giáo Việt nam 20/11','','','','','','')
INSERT INTO CongTac Values(N'Kế hoạch hoạt động nhằm giữ tỉ lệ học sinh theo học','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra tình hình giảng dạy – học tập của học sinh','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra hết môn ( theo tiến độ giảng dạy)','','','','','','')
INSERT INTO CongTac Values(N'Triển khai kế hoạch hoạt động chào mừng Ngày Nhà giáo Việt nam 20/11','','','','','','')
INSERT INTO CongTac Values(N'Dự giờ giáo viên mới','','','','','','')
INSERT INTO CongTac Values(N'Thống kê số học sinh thực học sau 1 tuần','','','','','','')
INSERT INTO CongTac Values(N'Thực hiện kế hoạch ổn định tỉ lệ học sinh','','','','','','')
INSERT INTO CongTac Values(N'Họp giao ban BCS lớp, GVCN lớp mới','','','','','','')
INSERT INTO CongTac Values(N'Thống kê số học sinh thực học sau 2 tuần','','','','','','')
INSERT INTO CongTac Values(N'Tổng kết, rút kinh nghiệm hội thảo','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra giữa học kỳ, phân chuyên ngành học sinh','','','','','','')
INSERT INTO CongTac Values(N'Tiếp xúc BGH + học sinh ','','','','','','')
INSERT INTO CongTac Values(N'Kế hoạch phân công giáo viên giảng dạy','','','','','','')
INSERT INTO CongTac Values(N'Kế hoạch thi HK . Đề thi + giáo viên coi thi','','','','','','')
INSERT INTO CongTac Values(N'Lịch thi HK','','','','','','')
INSERT INTO CongTac Values(N'Danh sách cán bộ coi thi','','','','','','')
INSERT INTO CongTac Values(N'Đề thi + giấy thi','','','','','','')
INSERT INTO CongTac Values(N'Kế hoạch hoạt động kỷ niệm ngày học sinh, sinh viên','','','','','','')
INSERT INTO CongTac Values(N'Hoạt động kỷ niệm ngày học sinh, sinh viên ','','','','','','')
INSERT INTO CongTac Values(N'Xác định số lượng đơn vị thực tập sản xuất','','','','','','')
INSERT INTO CongTac Values(N'Gửi công văn đến các doanh nghiệp xác định số lượng học sinh và thời gian thực tập sản xuất','','','','','','')
INSERT INTO CongTac Values(N'Chuẩn bị hồ sơ thi học kỳ','','','','','','')
INSERT INTO CongTac Values(N'Họp hội đồng thi học kỳ nhà trường','','','','','','')
INSERT INTO CongTac Values(N'Hoàn tất bảng điểm các môn kiểm tra','','','','','','')
INSERT INTO CongTac Values(N'Hoàn thành công tác chuẩn bị thi (danh sách học sinh đủ và không đủ điều kiện dự thi, đề thi, giấy thi, phòng thi)','','','','','','')
INSERT INTO CongTac Values(N'Ôn tập thi học kỳ','','','','','','')
INSERT INTO CongTac Values(N'Công bố đề cương ôn thi tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Thi học kỳ ','','','','','','')
INSERT INTO CongTac Values(N'Học sinh nghỉ tết Nguyên đán (02 tuần)','','','','','','')
INSERT INTO CongTac Values(N'Nhập điểm thi học kỳ','','','','','','')
INSERT INTO CongTac Values(N'Kế hoạch hoạt động chào mừng ngày thành lập Đoàn','','','','','','')
INSERT INTO CongTac Values(N'Tổ chức tham quan doanh nghiệp trước khi TTSX','','','','','','')
INSERT INTO CongTac Values(N'Đào tạo môn giáo dục quốc phòng ','','','','','','')
INSERT INTO CongTac Values(N'Dự trù vật tư thực hành','','','','','','')
INSERT INTO CongTac Values(N'Ôn tập học sinh thi lại','','','','','','')
INSERT INTO CongTac Values(N'Kế hoạch hoạt động chào mừng ngày thành lập Đoàn','','','','','','')
INSERT INTO CongTac Values(N'Tổ chức tham quan doanh nghiệp trước khi TTSX','','','','','','')
INSERT INTO CongTac Values(N'Danh sách khen thưởng, học bổng ','','','','','','')
INSERT INTO CongTac Values(N'Tổ chức thi học sinh giỏi nghề ASEAN','','','','','','')
INSERT INTO CongTac Values(N'Thi lại học kỳ ','','','','','','')
INSERT INTO CongTac Values(N'Kế hoạch hoạt động kỷ niệm ngày 26/3','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra hết môn ( theo tiến độ giảng dạy)','','','','','','')
INSERT INTO CongTac Values(N'Triển khai hoạt động kỷ niệm ngày 26/3','','','','','','')
INSERT INTO CongTac Values(N'Xác định số lượng doanh nghiệp TTSX','','','','','','')
INSERT INTO CongTac Values(N'Phân bổ số lượng học sinh TTSX/ doanh nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra giờ thực hành của học sinh','','','','','','')
INSERT INTO CongTac Values(N'Công văn gửi doanh nghiệp nhận học sinh TTSX','','','','','','')
INSERT INTO CongTac Values(N'Hoạt động văn – thể – mỹ chào mừng ngày 26/3','','','','','','')
INSERT INTO CongTac Values(N'Lịch thi HK + kế hoạch thực tập  sản xuất','','','','','','')
INSERT INTO CongTac Values(N'Đề cương ôn thi tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Phân công giáo viên ôn thi tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Sinh hoạt giáo viên hướng dẫn thực tập sản xuất và nội qui doanh nghiệp cho học sinh thực tập sản xuất','','','','','','')
INSERT INTO CongTac Values(N'Công bố nhu cầu tuyển dụng lao động của doanh nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Thi HK','','','','','','')
INSERT INTO CongTac Values(N'Thực tập sản xuất','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra tình hình thực tập sản xuất của học sinh','','','','','','')
INSERT INTO CongTac Values(N'Hoàn thành bảng điểm học tập','','','','','','')
INSERT INTO CongTac Values(N'Lập danh sách học sinh đủ và không đủ điều kiện dự thi tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Họp thông qua kế hoạch đào tạo ','','','','','','')
INSERT INTO CongTac Values(N'Họp ban cán sự lớp','','','','','','')
INSERT INTO CongTac Values(N'Kế hoạch thi tốt nghiệp gửi Phòng Dạy nghề','','','','','','')
INSERT INTO CongTac Values(N'Nộp đề thi tốt nghiệp + đáp án','','','','','','')
INSERT INTO CongTac Values(N'thi tốt nghiệp ( lý thuyết + thực hành)','','','','','','')
INSERT INTO CongTac Values(N'Họp hội đồng thi tốt nghiệp: thẩm định và chọn đề thi','','','','','','')
INSERT INTO CongTac Values(N'Nộp đề thi và đáp án học kỳ','','','','','','')
INSERT INTO CongTac Values(N'Nộp báo cáo thực tập sản xuất','','','','','','')
INSERT INTO CongTac Values(N'Học sinh nộp hình thi tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Niêm yết danh sách học sinh đủ điều kiện dự thi tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Ôn thi tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Danh sách phòng thi + số báo danh','','','','','','')
INSERT INTO CongTac Values(N'Họp hội đồng thi tốt nghiệp (xét duyệt danh sách học sinh đủ điều kiện dự thi.)','','','','','','')
INSERT INTO CongTac Values(N'Giải quyết các trường hợp không đủ điều kiện dự thi','','','','','','')
INSERT INTO CongTac Values(N'Tổ chức bảo vệ thử đồ án tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Hoàn tất bảng điểm các môn kiểm tra','','','','','','')
INSERT INTO CongTac Values(N'Báo cáo đồ án tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Thi tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Lập và niêm yết danh sách học sinh đủ và không đủ điều kiện dự thi học kỳ','','','','','','')
INSERT INTO CongTac Values(N'Chấm thi tốt nghiệp lý thuyết. Bảng điểm tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Lập danh sách thi lần 2 tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Ôn thi tốt nghiệp lần 2','','','','','','')
INSERT INTO CongTac Values(N'Thi tốt nghiệp lần 2','','','','','','')
INSERT INTO CongTac Values(N'Chấm thi học kỳ và nộp bài thi về phòng đào tạo','','','','','','')
INSERT INTO CongTac Values(N'Hoàn thành hồ sơ tốt nghiệp  gửi Phòng Dạy nghề','','','','','','')
INSERT INTO CongTac Values(N'Chuẩn bị lễ phát bằng tốt nghiệp','','','','','','')
INSERT INTO CongTac Values(N'Bảng phân công giáo viên giảng dạy ','','','','','','')
INSERT INTO CongTac Values(N'Chuẩn bị năm học mới','','','','','','')
INSERT INTO CongTac Values(N'Hoàn chỉnh chương trình đào tạo','','','','','','')
INSERT INTO CongTac Values(N'Tổng hợp đề cương chi tiết môn học','','','','','','')
INSERT INTO CongTac Values(N'Giáo viên biên soạn kế hoạch giảng dạy, giáo án theo qui định','','','','','','')
INSERT INTO CongTac Values(N'Tổng hợp điểm và thông báo kết quả học tập','','','','','','')
INSERT INTO CongTac Values(N'In bảng điểm cá nhân học sinh','','','','','','')
INSERT INTO CongTac Values(N'Kiểm tra hồ sơ chuẩn bị giảng dạy','','','','','','')
 